Alter TABLE Publisher
DROP CONSTRAINT DF_Publisher_Name

ALTER TABLE Publisher
ALTER COLUMN Name nvarchar(50) not null

ALTER TABLE Category
ALTER COLUMN Name nvarchar(50) not null

ALTER TABLE Book
ALTER COLUMN Name nvarchar(250) not null

ALTER TABLE Book
ALTER COLUMN Author nvarchar(200)

/****** Object:  Table [dbo].[Note]    Script Date: 03/11/2010 16:38:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Note](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](200) NOT NULL,
	[Description] [nvarchar](max) NULL,
	[CreatedDate] [datetime] NOT NULL,
	[Reference] [nvarchar](max) NULL,
	[CategoryID] [int] NOT NULL,
 CONSTRAINT [PK_Note] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object:  ForeignKey [FK_Note_Category]    Script Date: 03/11/2010 16:38:18 ******/
ALTER TABLE [dbo].[Note]  WITH CHECK ADD  CONSTRAINT [FK_Note_Category] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Category] ([ID])
GO
ALTER TABLE [dbo].[Note] CHECK CONSTRAINT [FK_Note_Category]
GO